2014-10-06 - 10735.1200 - Spec - POS Extract Japan - (Craig by 2015-01-26) #JapanSD #JapanABAP #ABAPEXTRACT #APAC #SDMiscellaneousReports

SPECIFICATIONS 10735: Spec - POS Extract Japan

Purpose

Create Material/item and Price extract programs especially for Japan.

Admin Info

Purpose
 Create Material/item and Price extract programs especially for Japan
Requested By
 Craig Spangler
Spec Created By
 Deepak Yasam
Spec Created Date
 10/06/2014
Spec QA by
 Deepak Yasam
Objects
 ZSD_JPN_PRICE_EXTRACT
ZSD_JPN_ITEM_EXTRACT
Document Status
 Complete

Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 00
2
 Documentation
 04
3
 Development/ Config
 20
4
 Unit test in DEV
 04
5
 Unit test in QUA
 04
6
 Other activity

TOTAL
 32
References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

None

Documents

[Attach any document(s) received for the requirement(s)]


JPN_POS_Extract.xlsx


Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]



Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 To include the product attribute 5(Retail) flagged materials in both the programs and to add the PH3 values in the Item extract file in column 1
 Craig Spangler
 10/08/2014
 N/A
2
 To display the content of the item extract file that is uploaded to the application server
 Craig Spangler
 10/17/2014
 N/A
3
 Include file name generation in the program
 Craig Spangler
 12/12/2014
 N/A
4
 Include file name for POS extracts with time stamp
 Craig Spangler
 12/18/2014
 N/A
5
 Prefix "01" to the file name e.g. ITEM0120150114142010.txt
 Craig Spangler
 01/14/2015
 N/A
6
 Add CR LF unicode to the Item and Price Extracts
 Craig Spangler
 01/19/2015
 N/A

Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

Create Material/item and Price extract programs especially for Japan

In Scope:

[List the activities to be included in scope]
These programs are limited to the Japan sales orgs.
Only the retail attribute ie., product attribute 5 flagged materials are considered in the output file.

Out of Scope:

[Out of scope activities
The retail attribute unflagged materials are not included in the output file of the item and price extract programs.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

Need to create two seperate programs ie., for price and item extract with the desired selection criteria and should be downlaoded to both application and presentation servers.The programs should consider the materials with the product attribute 5 ie., retail flagged of the corresponding selection screen inputs ie., sales org and plant.

The PH3 values in the materials should be dispalyed based on the matching code in column 1 in the item extract program output file as below.

B 12
F 11
G 12
L 11
M 10
N 99
W 11
Y 12

Test Plan

[List test scenarios/cases to be executed here]

Test ID
 Test Scenario
 Expected Results
SD-001
 Execute ZSD_JPN_PRICE_EXTRACT program with 3200 sales org,0610 palnt as inputs.Download the file to the desktop and application server by maintaining the desired file path or location.
 The price extract file should be downloaded to both application and presentation servers with the desired values.Only the materials with product attribute 5 ie., reatil flagged are considered in the file.
SD-002
 Execute ZSD_JPN_ITEM_EXTRACT program with 3200 sales org,0610 palnt as inputs.Download the file to the desktop and application server by maintaining the desired file path or location.
 The Item extract file should be downloaded to both application and presentation servers with the desired values.Only the materials with product attribute 5 ie., reatil flagged are considered in the file.

For Item Extract:
Test ID
 Test Scenario
 Expected Results
SD-001
 Execute ZSD_JPN_ITEM_EXTRACT program with sales org 3200 , plant 0610 and directory in the application server as inputs (/usr/sap/NED/RETAIL/Japan/IN/Itemextract.txt). .
 The Item extract file should be uploaded into the specified application server directory and display the contents in the file.
SD-002
 Execute ZSD_JPN_ITEM_EXTRACT program with sales org 3200 , plant 0610 directory in the application server (/usr/sap/NED/RETAIL/Japan/IN/Itemextract2.txt) and front end file path,file name as inputs.
 1.The Item extract file should be uploaded into the specified application server directory with the contents in the file. 2.Download the file to front end with the specified file name and display the contents in the file.
SD-003
 Execute ZSD_JPN_ITEM_EXTRACT program with sales org 3200 , plant 0610 and front end file path,file name as inputs.
 The Item extract file should be download to front end with the specified file name and display the contents in the file.
SD-004
 Execute ZSD_JPN_ITEM_EXTRACT program with sales org 3200 , plant 0610 and wrong directory in the application server as inputs (/usr/sap/NEDRETAIL/Japan/IN/Itemextract.txt).
 An error log should be dispalyed saying wrong file path.
SD-005
 Execute ZSD_JPN_ITEM_EXTRACT program with sales org 3200 , plant 0610 directory in the application server as inputs (/usr/sap/NED/RETAIL/Japan/IN/ItemextractBJ.txt) in background
 The Item extract file should be uploaded into the specified application server directory and display the contents in the file.

For Price Extract:

Test ID
 Test Scenario
 Expected Results
SD-001
 Execute ZSD_JPN_PRICE_EXTRACT program with sales org 3200 , plant 0610 and directory in the application server as inputs (/usr/sap/NED/RETAIL/Japan/IN/Priceextract.txt). .
 The Price extract fileshould be uploaded into the specified application server directory and display the contents in the file.
SD-002
 Execute ZSD_JPN_PRICE_EXTRACT program with sales org 3200 , plant 0610 directory in the application server (/usr/sap/NED/RETAIL/Japan/IN/Priceextract2.txt) and front end file path,file name as inputs.
 1.The Price extract fileshould be uploaded into the specified application server directory with the contents in the file. 2.Download the file to front end with the specified file name and display the contents in the file.
SD-003
 Execute ZSD_JPN_PRICE_EXTRACT program with sales org 3200 , plant 0610 and front end file path,file name as inputs.
 The Price extract fileshould be download to front end with the specified file name and display the contents in the file.
SD-004
 Execute ZSD_JPN_PRICE_EXTRACT program with sales org 3200 , plant 0610 and wrong directory in the application server as inputs (/usr/sap/NEDRETAIL/Japan/IN/Priceextract.txt).
 An error log should be dispalyed saying wrong file path.
SD-005
 Execute ZSD_JPN_PRICE_EXTRACT program with sales org 3200 , plant 0610 directory in the application server as inputs (/usr/sap/NED/RETAIL/Japan/IN/PriceextractBJ.txt) in background.
 The Price extract fileshould be uploaded into the specified application server directory and display the contents in the file.
For File Name with Time Stamp

Test ID
 Test Scenario
 Expected Results
SD-001
 Execute the program ZSD_JPN_ITEM_EXTRACT
in background with the following inputs-
Sales Org - 3200
Plant - 0610
Directory - /tmp/
 The file should be saved in the directory with the time stamp as text file
SD-002
 Execute the program ZSD_JPN_PRICE_EXTRACT
in background with the following inputs-
Sales Org - 3200
Plant - 0610
Directory - /tmp/
 The file should be saved in the directory with the time stamp as text file
SD-003
 Run the programs again in background
 Two separate files should be saved on the application server in the
specified directory
Test Scenarios for file name prefix:
Test ID
 Test Scenario
 Expected Results
SD-001
 Execute the program ZSD_JPN_ITEM_EXTRACT in background with the following inputs- Sales Org - 3200 Plant - 0610 Directory - /tmp/
 The file should be saved in the directory with the prefix 01 in the file name
SD-002
 Execute the program ZSD_JPN_PRICE_EXTRACT in background with the following inputs- Sales Org - 3200 Plant - 0610 Directory - /tmp/
 The file should be saved in the directory with the prefix 01 in the file name
For Extracts with CR LF (Carriage Return & Line Feed)
Test ID
 Test Scenario
 Expected Results
SD-001
 Execute the program ZSD_JPN_ITEM_EXTRACT
in background with the following inputs-
Sales Org - 3200
Plant - 0610
Directory - /tmp/
 The file should be saved in the directory and the extract when opened
in Notepad ++ should display CR and LF
SD-002
 Execute the program ZSD_JPN_PRICE_EXTRACT
in background with the following inputs-
Sales Org - 3200
Plant - 0610
Directory - /tmp/
 The file should be saved in the directory and the extract when opened
in Notepad ++ should display CR and LF
SD-003
 Run the programs again in background
 The file should be saved in the directory and the extract when opened
in Notepad ++ should display CR and LF

Solution Details

[Provide complete technical details for configuration or programming here]

Price Extract:

Develop Price Extract Program for the materials which are flagged for Retail Pro( i,e. Product Attribute 5 ) Master data, the extract file will be placed in application server with an option to download to desktop.

Selection Criteria:


-Sales Organization
-Plant

- Application Server Path
- Check Box - Download to Desktop
- Desktop File Path

Output :

-UPC Number : MEAN-EAN11
-MSRP Price Value
-Price Level : This field is always '1'.

Item/Material Extract:


Develop a Program to generate extract file materials which are flagged for retail pro ( i,e. Product Attribute 5) in Master Data. The extract file should be placed in Application Server with option to download to desktop.

Selection Criteria:


-Sales Organization
-Plant

- Application Server Path
- Check Box - Download to Desktop
- Desktop File Path

Output :

- Gendor Code - Picked from Product Heirararchy 3
- Vendor Code - Always "NEWERA"
-Style - Product Heirarchy 4 Text
- Type - Product Hierarchy 1 Text
- Team Name - Product Hierarchy 7 Text
- Material Description
- Color
- Size - MEAN - J_3AKORDX
- JAN Code - UPC Number - MEAN-EAN11
- Item Code - Blank
- Stock Code - Blank
-Stock Name - Blank
- Unit Price - Blank
- Cost - Blank
- Team Name2 - Blank
- Style Code4 - Product Hierarchy 4
- Type Code - Product Hierarchy 1
- Team Code - Product Hierarchy 7
- Size-Code - MEAN - J_3AKORDX
- Brand Code - Blank
- Brand Name - Blank

Solution for changing file name with time stamp

Captured the existing file name and passed in to the separate string along with date, time, and .txt text using the concatenate syntax statement.

Issues

[List Issues / Bugs identified in configuration or development]